﻿<%@ Page Language="C#" MasterPageFile="~/Department/DepartmentMasterPage.master" AutoEventWireup="true" CodeFile="showStudentsInfo.aspx.cs" Inherits="Department_showStudentsInfo" Title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
                &nbsp;<div style="border-left-color: #6699ff; border-bottom-color: #6699ff; width: 100%;
        border-top-style: solid; border-top-color: #6699ff; border-right-style: solid;
        border-left-style: solid; height: 190%; border-right-color: #6699ff; border-bottom-style: solid">
                    <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
                        AutoGenerateColumns="False" CellPadding="4" DataKeyNames="st_id" DataSourceID="SqlDataSource1"
                        ForeColor="#333333" GridLines="None" Height="378px" Style="border-right: thin double;
                        border-top: thin double; border-left: thin double; border-bottom: thin double" OnSelectedIndexChanged="GridView1_SelectedIndexChanged" PageSize="6">
                        <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
                        <Columns>
                            <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" ShowSelectButton="True" />
                          <asp:HyperLinkField HeaderText="学  号" DataTextField="st_id" DataNavigateUrlFields="st_id,st_photoUrl" DataNavigateUrlFormatString="oneStudentinfo.aspx?id={0}&amp;photoUrl={1}" Target="_blank" />
                            <asp:BoundField DataField="st_pwd" HeaderText="st_pwd" SortExpression="st_pwd" />
                            <asp:BoundField DataField="cl_id" HeaderText="cl_id" SortExpression="cl_id" />
                            <asp:HyperLinkField HeaderText="姓名" DataTextField="st_name" DataNavigateUrlFields="st_id,st_photoUrl" DataNavigateUrlFormatString="oneStudentinfo.aspx?id={0}&amp;photoUrl={1}" Target="_blank" />
                            <asp:BoundField DataField="st_sex" HeaderText="st_sex" SortExpression="st_sex" />
                            <asp:BoundField DataField="st_birthday" HeaderText="st_birthday" SortExpression="st_birthday" />
                            <asp:BoundField DataField="st_identity" HeaderText="st_identity" SortExpression="st_identity" />
                            <asp:BoundField DataField="st_photoUrl" HeaderText="st_photoUrl" SortExpression="st_photoUrl" />
                            <asp:BoundField DataField="st_timeOfEntryS" HeaderText="st_timeOfEntryS" SortExpression="st_timeOfEntryS" />
                            <asp:BoundField DataField="st_passportNum" HeaderText="st_passportNum" SortExpression="st_passportNum" />
                            <asp:BoundField DataField="st_timeOfPassport" HeaderText="st_timeOfPassport" SortExpression="st_timeOfPassport" />
                            <asp:BoundField DataField="st_totalG" HeaderText="st_totalG" SortExpression="st_totalG" />
                            <asp:BoundField DataField="st_lOE" HeaderText="st_lOE" SortExpression="st_lOE" />
                            <asp:BoundField DataField="st_lOC" HeaderText="st_lOC" SortExpression="st_lOC" />
                            <asp:BoundField DataField="st_hsk" HeaderText="st_hsk" SortExpression="st_hsk" />
                            <asp:BoundField DataField="st_fatherName" HeaderText="st_fatherName" SortExpression="st_fatherName" />
                            <asp:BoundField DataField="st_fatherTel" HeaderText="st_fatherTel" SortExpression="st_fatherTel" />
                            <asp:BoundField DataField="st_fatherEm" HeaderText="st_fatherEm" SortExpression="st_fatherEm" />
                            <asp:BoundField DataField="st_motherName" HeaderText="st_motherName" SortExpression="st_motherName" />
                            <asp:BoundField DataField="st_motherTel" HeaderText="st_motherTel" SortExpression="st_motherTel" />
                            <asp:BoundField DataField="st_motherEm" HeaderText="st_motherEm" SortExpression="st_motherEm" />
                            <asp:BoundField DataField="st_remark" HeaderText="st_remark" SortExpression="st_remark" />
                        </Columns>
                        <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                        <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
                        <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
                        <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                        <EditRowStyle BackColor="#999999" />
                        <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
                    </asp:GridView>
                    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:StudentManagerConnectionString3 %>"
                        DeleteCommand="DELETE FROM [student] WHERE [st_id] = @st_id" InsertCommand="INSERT INTO [student] ([st_id], [st_pwd], [cl_id], [st_name], [st_sex], [st_birthday], [st_identity], [st_photoUrl], [st_timeOfEntryS], [st_passportNum], [st_timeOfPassport], [st_totalG], [st_lOE], [st_lOC], [st_hsk], [st_fatherName], [st_fatherTel], [st_fatherEm], [st_motherName], [st_motherTel], [st_motherEm], [st_remark]) VALUES (@st_id, @st_pwd, @cl_id, @st_name, @st_sex, @st_birthday, @st_identity, @st_photoUrl, @st_timeOfEntryS, @st_passportNum, @st_timeOfPassport, @st_totalG, @st_lOE, @st_lOC, @st_hsk, @st_fatherName, @st_fatherTel, @st_fatherEm, @st_motherName, @st_motherTel, @st_motherEm, @st_remark)"
                        SelectCommand="SELECT * FROM [student]" UpdateCommand="UPDATE [student] SET [st_pwd] = @st_pwd, [cl_id] = @cl_id, [st_name] = @st_name, [st_sex] = @st_sex, [st_birthday] = @st_birthday, [st_identity] = @st_identity, [st_photoUrl] = @st_photoUrl, [st_timeOfEntryS] = @st_timeOfEntryS, [st_passportNum] = @st_passportNum, [st_timeOfPassport] = @st_timeOfPassport, [st_totalG] = @st_totalG, [st_lOE] = @st_lOE, [st_lOC] = @st_lOC, [st_hsk] = @st_hsk, [st_fatherName] = @st_fatherName, [st_fatherTel] = @st_fatherTel, [st_fatherEm] = @st_fatherEm, [st_motherName] = @st_motherName, [st_motherTel] = @st_motherTel, [st_motherEm] = @st_motherEm, [st_remark] = @st_remark WHERE [st_id] = @st_id">
                        <DeleteParameters>
                            <asp:Parameter Name="st_id" Type="String" />
                        </DeleteParameters>
                        <UpdateParameters>
                            <asp:Parameter Name="st_pwd" Type="String" />
                            <asp:Parameter Name="cl_id" Type="String" />
                            <asp:Parameter Name="st_name" Type="String" />
                            <asp:Parameter Name="st_sex" Type="String" />
                            <asp:Parameter Name="st_birthday" Type="String" />
                            <asp:Parameter Name="st_identity" Type="String" />
                            <asp:Parameter Name="st_photoUrl" Type="String" />
                            <asp:Parameter Name="st_timeOfEntryS" Type="String" />
                            <asp:Parameter Name="st_passportNum" Type="String" />
                            <asp:Parameter Name="st_timeOfPassport" Type="String" />
                            <asp:Parameter Name="st_totalG" Type="Int16" />
                            <asp:Parameter Name="st_lOE" Type="String" />
                            <asp:Parameter Name="st_lOC" Type="String" />
                            <asp:Parameter Name="st_hsk" Type="String" />
                            <asp:Parameter Name="st_fatherName" Type="String" />
                            <asp:Parameter Name="st_fatherTel" Type="String" />
                            <asp:Parameter Name="st_fatherEm" Type="String" />
                            <asp:Parameter Name="st_motherName" Type="String" />
                            <asp:Parameter Name="st_motherTel" Type="String" />
                            <asp:Parameter Name="st_motherEm" Type="String" />
                            <asp:Parameter Name="st_remark" Type="String" />
                            <asp:Parameter Name="st_id" Type="String" />
                        </UpdateParameters>
                        <InsertParameters>
                            <asp:Parameter Name="st_id" Type="String" />
                            <asp:Parameter Name="st_pwd" Type="String" />
                            <asp:Parameter Name="cl_id" Type="String" />
                            <asp:Parameter Name="st_name" Type="String" />
                            <asp:Parameter Name="st_sex" Type="String" />
                            <asp:Parameter Name="st_birthday" Type="String" />
                            <asp:Parameter Name="st_identity" Type="String" />
                            <asp:Parameter Name="st_photoUrl" Type="String" />
                            <asp:Parameter Name="st_timeOfEntryS" Type="String" />
                            <asp:Parameter Name="st_passportNum" Type="String" />
                            <asp:Parameter Name="st_timeOfPassport" Type="String" />
                            <asp:Parameter Name="st_totalG" Type="Int16" />
                            <asp:Parameter Name="st_lOE" Type="String" />
                            <asp:Parameter Name="st_lOC" Type="String" />
                            <asp:Parameter Name="st_hsk" Type="String" />
                            <asp:Parameter Name="st_fatherName" Type="String" />
                            <asp:Parameter Name="st_fatherTel" Type="String" />
                            <asp:Parameter Name="st_fatherEm" Type="String" />
                            <asp:Parameter Name="st_motherName" Type="String" />
                            <asp:Parameter Name="st_motherTel" Type="String" />
                            <asp:Parameter Name="st_motherEm" Type="String" />
                            <asp:Parameter Name="st_remark" Type="String" />
                        </InsertParameters>
                    </asp:SqlDataSource>
    </div>
</asp:Content>

